/***************************************************************************
 *   Copyright (C) 2007 by Grzegorz Latarowski, Maciej Gajewski            *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/




#ifndef EVENT_BASE_CONNECTION_H
#define EVENT_BASE_CONNECTION_H

// Qt
#include <QtSql>
#include <QString>

// gcommon
#include "gexception.h"


const char * EVENTS_DATABASE_NAME = "AUTOSTOP";



// ------------------- createEventsBase() ------------------------------------
static void createEventsBase()
{
	QSqlQuery query;
        
        // create event table
    query.exec(
			"CREATE TABLE IF NOT EXISTS autostop_events ("
            "ID INTEGER PRIMARY KEY,"        // ID auto increment
			"Type INTEGER(8),"			     // Event type
			"Date TEXT,"                 // Event dateTime
			"Message TEXT)"                  // event message
              );
	
	query.exec(
			"CREATE TABLE IF NOT EXISTS autostop_events_first_images ("
			"id INTEGER PRIMARY KEY,"        // ID 
			"image BLOB)"                    // Image 
			  );
	
	query.exec(
			"CREATE TABLE IF NOT EXISTS autostop_events_second_images ("
			"id INTEGER PRIMARY KEY,"        // ID 
			"image BLOB)"                    // Image 
			  );
}
// ---------------------------------------------------------------------------


// ----------------- createEventBaseConnection() -----------------------------
static void createEventBaseConnection( const QString & fileName )
{    
    QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" );
// 	db.setDatabaseName( EVENTS_DATABASE_NAME );
    
		// open data base 
    db.setDatabaseName( fileName );
    if( !db.open() )
	{
		QString errorMessage = QString( "Can not create data base connection. %1 '%2'" ).arg( db.lastError().text() ).arg( fileName );
		throw GSysError( errorMessage );
    }
	
	createEventsBase();
}
// ---------------------------------------------------------------------------



#endif // EVENT_BASE_CONNECTION_H

// eof
